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