UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CWO6kcDx1XxAdGgx8ErqMTJBimtbRd7e+SOjjNcQO8='
WHERE
key_id = 'd05e6a05114536298a40c2f422fd7702167728f8dba84873c691ae9f97b7c615'
AND (
token = '8CWO6kcDx1XxAdGgx8ErqMTJBimtbRd7e+SOjjNcQO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)