UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lzmLgK/HO8377a+VU48smuyWT5vphhi/GxNr4WG5FOs='
WHERE
key_id = '23eae222f1f863442b8db67c10facae8aa58ff5c30e4b798291af181ab0fa5d0'
AND (
token = 'lzmLgK/HO8377a+VU48smuyWT5vphhi/GxNr4WG5FOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)