UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ncz2DQdQ1D9jl3ttT8uJr6cP2mtQMKNdiJ0VCv01aQU=' 
WHERE 
  key_id = '623db7d0548d07a61f328d37ccaeaf23ab2636b32f4a9ac22eadef3da838cd86' 
  AND (
    token = 'Ncz2DQdQ1D9jl3ttT8uJr6cP2mtQMKNdiJ0VCv01aQU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038