UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oIV9BEvPocJY/+wURSJHfTY3YUJ04KGfuyk50WqyuwY=' 
WHERE 
  key_id = 'a7ee0b3da7f6218b52d3f73f732b1e17bff8fe1cf190950ec5ab0839ec353584' 
  AND (
    token = 'oIV9BEvPocJY/+wURSJHfTY3YUJ04KGfuyk50WqyuwY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022