UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49iBmAeJWF2lvj7qhZNSMWBgP2ASFBznc97MKgKiVo0='
WHERE
key_id = '92f8e230f1329d683ee010e35e6d36367803e56033cc1de4061d06bbc2230743'
AND (
token = '49iBmAeJWF2lvj7qhZNSMWBgP2ASFBznc97MKgKiVo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)