UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xGZPdZb++H98Z4Rp7v6o/yhgil632r5p6dEL+0D43WU=' 
WHERE 
  key_id = 'b46ae49eab0f9af3bbba04eed44e85067dd82e8e8ff5a8acbda3df835ed4d682' 
  AND (
    token = 'xGZPdZb++H98Z4Rp7v6o/yhgil632r5p6dEL+0D43WU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00051