UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zFkAlNADC1U16eYnjAMZfYOcmNhR6YkkfYGeE1dEwxw='
WHERE
key_id = 'f0adad1b254fe38996d8d6c6b0e2665f668121f3de3a83378df39076e80fd6c2'
AND (
token = 'zFkAlNADC1U16eYnjAMZfYOcmNhR6YkkfYGeE1dEwxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)