UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EW1LZFeZsm06fWhWjeBI7kIh8Y1gWg81jEv0y6aMncU='
WHERE
key_id = '1cc45f539c6b327ba0927e7b79c8e7300e891d359f6dca4fdfd18478df221349'
AND (
token = 'EW1LZFeZsm06fWhWjeBI7kIh8Y1gWg81jEv0y6aMncU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)