UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lxaI6xG8baZ4DdGS42q5l7ZeIbmm/vSMPRu6i5pAAh4='
WHERE
key_id = '3304efeb3e32f431cb8a2aa413c1ac58da23046ae4fb4e72f081d5b19d1fbbb3'
AND (
token = 'lxaI6xG8baZ4DdGS42q5l7ZeIbmm/vSMPRu6i5pAAh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)