UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7wf6TS2VxEf8nWLoWc12WhKMzJ0BDmJDzuLj+EL0BAY='
WHERE
key_id = '6296a2b59cf1d273541e73134992867b42e92c1c3fbf5e7a1701ca28672860b0'
AND (
token = '7wf6TS2VxEf8nWLoWc12WhKMzJ0BDmJDzuLj+EL0BAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)