UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rrfZBE93gh9PcGE9wgH3X5ejZuoyLyOwKhnEJssz0Sk=' 
WHERE 
  key_id = '708c1960a6f23f64a36c50e1fdbf66c9efd620d5ca5a2400df006e6b76a8575f' 
  AND (
    token = 'rrfZBE93gh9PcGE9wgH3X5ejZuoyLyOwKhnEJssz0Sk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022