UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49TheZAQAOafp6StMg4KjACrGX8xXVgKoJAWogV5i+g='
WHERE
key_id = '14d17910ddc57410ed2af768c20b5157f5f34a7797767b53eff9d9797cc1ae2e'
AND (
token = '49TheZAQAOafp6StMg4KjACrGX8xXVgKoJAWogV5i+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)