UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKHyTVdW/skM573yOxdbDt0U3RQ0q7muG4r0kY5ZFDE='
WHERE
key_id = 'd7d4d6523e68fa3c07a7b287442ac8e680cb6d98a3b792733a55a1a3654d23d6'
AND (
token = 'zKHyTVdW/skM573yOxdbDt0U3RQ0q7muG4r0kY5ZFDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)