UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n8kQjIrHBv24MLccRgF54rK8QBNfcefNbPkpAw56HeQ='
WHERE
key_id = '720afe65466f48432c04d5b0c91488978eaaa0c6740a2d3ca525135ba9f057ea'
AND (
token = 'n8kQjIrHBv24MLccRgF54rK8QBNfcefNbPkpAw56HeQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)