UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kYX4bnoEyAcDM0jmf7Kd1Egzm1w+Fb3Ax0OUn0by06Y='
WHERE
key_id = 'fe7e4b54e12bd0aece0836b0a501b6176ee34f5b5187ed7f4cd8d15e72cb9877'
AND (
token = 'kYX4bnoEyAcDM0jmf7Kd1Egzm1w+Fb3Ax0OUn0by06Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)