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