UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GW0fuu3DHH1TyOE0C7qdeaB9MDOsDcq3mXlbweoXI4='
WHERE
key_id = '55979919ca3a8f4863ba7862c9a2457a6d2ba476639a73297012447a9a80fe54'
AND (
token = '8GW0fuu3DHH1TyOE0C7qdeaB9MDOsDcq3mXlbweoXI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)