UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7LF2pYjrvKGZEx+0YVA9G2LYoi4LHgMI0v+0Pdt6m+s='
WHERE
key_id = 'f99310f7707deba89a64630f85c1de2c2fe443a2d477d79e0e3f28f1d2da3ac2'
AND (
token = '7LF2pYjrvKGZEx+0YVA9G2LYoi4LHgMI0v+0Pdt6m+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)