UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TQPa60cELzPDtjZZtF+A29ISX0nVxBwMpd4CHN+srT4='
WHERE
key_id = 'b38a7e66773def87db963e972c37454ecef718a4355eb83f91228d6ef40c1139'
AND (
token = 'TQPa60cELzPDtjZZtF+A29ISX0nVxBwMpd4CHN+srT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)