UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4QzyCFeb51EhvzE05MOcbnZFh8cIkVsjnVd//a6JGcM='
WHERE
key_id = '48b40ce8a0f70b96def3bde9f401f065403e5e3a356f1d2705ffee1cfd3e347d'
AND (
token = '4QzyCFeb51EhvzE05MOcbnZFh8cIkVsjnVd//a6JGcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)