UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4k6pUKOBnl7DIML6VgcY9+/JdclAkVTHnsuI0s81yIA='
WHERE
key_id = '1ffa01569eb93446b9e0967b43ace6d65ef9ee6d0a55f22a613d805842af79d1'
AND (
token = '4k6pUKOBnl7DIML6VgcY9+/JdclAkVTHnsuI0s81yIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)