UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ZkCkcTOyHaxZ+G90Uph8g+2BGpVwJb4F18cw0syNUc='
WHERE
key_id = 'e12bac1ae4354ec97bf3149eac7ff491d63639df31b42f7d4490ff07edb4fb52'
AND (
token = '7ZkCkcTOyHaxZ+G90Uph8g+2BGpVwJb4F18cw0syNUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)