UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xyWVKg93g3zZflM+ySXFuUlEzhhpn81+mYT91HxqvM='
WHERE
key_id = '4983a8530ba5335e899cc43031aba8838a32fafca6844fd7882655750c2afb9f'
AND (
token = '6xyWVKg93g3zZflM+ySXFuUlEzhhpn81+mYT91HxqvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)