UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AZ9pbo3vQar0Bogb2x3hKOmEmIHgJZqCmM9YPfG57PM=' 
WHERE 
  key_id = '6043e235e6cba694f5985a5dbe3aac93c815f6a94ce2b2828e25aa61230e9026' 
  AND (
    token = 'AZ9pbo3vQar0Bogb2x3hKOmEmIHgJZqCmM9YPfG57PM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042