UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'secs1Ea0802k+bkfJowHLGi81a8MC2gZDYHqBpai52E='
WHERE
key_id = '78aa58a8d0d094a95a089b3e4bd891837c20d755b0f77612daf37cd08214828c'
AND (
token = 'secs1Ea0802k+bkfJowHLGi81a8MC2gZDYHqBpai52E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)