UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8iyIE9iOkwFxJS0LRX8juocvMt4QutO8MjjchPCFbBw='
WHERE
key_id = '4fdb5a954837122fd8535d610d2869cf908b818710f99c9aad569b85fe9e3d2a'
AND (
token = '8iyIE9iOkwFxJS0LRX8juocvMt4QutO8MjjchPCFbBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)