UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJooJJoHI55/Y5CtIIWg2ogJ42edkWpDEo6ehycYidU='
WHERE
key_id = 'dab6c0212ee8057b9ba3956173029847ba70e4c669da222778954fb779b9f47b'
AND (
token = 'xJooJJoHI55/Y5CtIIWg2ogJ42edkWpDEo6ehycYidU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)