UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '93A0h6KMr3YcxVSAGw+F62tYUAkmtCgEfpefD3T73Ug='
WHERE
key_id = '1974ee8182113f7e0ac711d52f2c636ba8b4b7de9e0ea834ad6d6a823574fac1'
AND (
token = '93A0h6KMr3YcxVSAGw+F62tYUAkmtCgEfpefD3T73Ug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)