UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BpUpthXMjm640+FcWeOCxR52nFA4n+dEHMMBLKUS7FU='
WHERE
key_id = '8924f091bf34348265a900f7d1814c101a2b0d73a78c86efe3e2eebccbe79dde'
AND (
token = 'BpUpthXMjm640+FcWeOCxR52nFA4n+dEHMMBLKUS7FU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)