UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H7lWC627TBIH3JjZWXj0rFL1Cm+zhmD6VYPufBKx1ic='
WHERE
key_id = 'd299728940b48d0155912d37ed8a1e3056f44886a9755a8ce042bd9db0684cd2'
AND (
token = 'H7lWC627TBIH3JjZWXj0rFL1Cm+zhmD6VYPufBKx1ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)