UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aVRkiXqCHH3kjGDyPW2Q7zDLNp4opb28epE9wPi0SyU='
WHERE
key_id = 'ad8ca198f8bc34f3c0b59561e81d32830df9fc165e8093ed253d067c6f70f55a'
AND (
token = 'aVRkiXqCHH3kjGDyPW2Q7zDLNp4opb28epE9wPi0SyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)