UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T2DdU9toP0rg0XwZXZ6u73lWVV6AL2PbZYsdGw8lKqw='
WHERE
key_id = '2ef1029343f3c1d0a4dedf77c2e1b87a0b4f25f9a2f06a960effb43f678613bd'
AND (
token = 'T2DdU9toP0rg0XwZXZ6u73lWVV6AL2PbZYsdGw8lKqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)