UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KzdHeVzd873gjCjNxvln6vwrzmkrp6O+653r/RgCywg='
WHERE
key_id = 'a8934defbb980487cd03bb1e3838ec5119644f66fc7eae8565a1410bed3025a3'
AND (
token = 'KzdHeVzd873gjCjNxvln6vwrzmkrp6O+653r/RgCywg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)