UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Y3U/ErEMZDOnPOmlzcV/i4qE/7dBL83eq4enWvQ8SRU=' 
WHERE 
  key_id = '7dec4a6cb5ac90843cabe4740c3d0d0ca2c10d6a19042b4083b6cba89abe9153' 
  AND (
    token = 'Y3U/ErEMZDOnPOmlzcV/i4qE/7dBL83eq4enWvQ8SRU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026