UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2/carVW/sOPnndbHZGmbQPPX8dmGK1Jz0psUaXufKig=' 
WHERE 
  key_id = 'a0e2b175c4c03a62a9db31cbb5e9aaa079efcf61b4d7e025b4d482b44f76d02d' 
  AND (
    token = '2/carVW/sOPnndbHZGmbQPPX8dmGK1Jz0psUaXufKig=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031