UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4c5iDY0ODyp6xAIx8NiUC7jw6hAC7PRMV0+5ldVTi3g='
WHERE
key_id = '8fc06a5b0cc2551697e960c21e992d6cf88488949ddc2020178a03608d3f181a'
AND (
token = '4c5iDY0ODyp6xAIx8NiUC7jw6hAC7PRMV0+5ldVTi3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)