UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IL6sYqYjBcaX3DPB8hYBIm9yNMjPZawZLXlLLbhFM14='
WHERE
key_id = 'dc97c969b1d541fbf7c1a9bfbac49dc1bafbd567cf27144e54c09298dbb84634'
AND (
token = 'IL6sYqYjBcaX3DPB8hYBIm9yNMjPZawZLXlLLbhFM14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)