UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S+CGMuntcRiUbKQzYibFKzdU+V9kxtYeAVGlyS+fmpw='
WHERE
key_id = '536321ff41aa7c02053866f6737d90c7e1ca86787d6c68d4c476553636eb15ae'
AND (
token = 'S+CGMuntcRiUbKQzYibFKzdU+V9kxtYeAVGlyS+fmpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)