UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Bh5cAWtHWknaHoh+6DU2FGa1Rp61GpkZNK2ie24y+zk=' 
WHERE 
  key_id = '2fa1c266426140819886847675becc8f16258cef387314640230a5dc97b12481' 
  AND (
    token = 'Bh5cAWtHWknaHoh+6DU2FGa1Rp61GpkZNK2ie24y+zk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030