UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdbULoKzGB5RrkOPuZJuUAestCAUzozEOwDGEY6nXTo='
WHERE
key_id = 'e9bab7ede640502cad52855e6f0f4f0b057d6ee1f9b9dc23f0946ac11558bc17'
AND (
token = 'zdbULoKzGB5RrkOPuZJuUAestCAUzozEOwDGEY6nXTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)