UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mSTpnwB+oy5+jSt3jX53F+/OX8o6RgNKqpTHdfz69ck='
WHERE
key_id = '767e4ab9bb50ffdfbe78b8c3e2f727000bd288d90f1212cf6fb14b34a6845ccc'
AND (
token = 'mSTpnwB+oy5+jSt3jX53F+/OX8o6RgNKqpTHdfz69ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)