UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hA1ndmqAJ12oWNr7NmYgZy8lnsbk7V6bnu6ktzZv7Rk='
WHERE
key_id = '03de1d850bfc5e296f3e21237b3fd78601a9a445a0fff17d9065b05dbc32bc8e'
AND (
token = 'hA1ndmqAJ12oWNr7NmYgZy8lnsbk7V6bnu6ktzZv7Rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)