UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wUE9S+VNNkth/+k7xsHiMYsm6LDzigS2uGIhJnxhV04=' 
WHERE 
  key_id = '5902532ef8732821084d489fab8151be1a3a8f6cda9595eb97ab27feba24bc01' 
  AND (
    token = 'wUE9S+VNNkth/+k7xsHiMYsm6LDzigS2uGIhJnxhV04=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032